package me.lwn.auth.security.utils;

public interface UserDetailsSqlConstants {

    String CREATE_USER_SQL = "insert into user (id, username, password, name, mobile, email, head_image, account_expire_date, credential_expire_date, account_locked, enabled) values (?,?,?,?,?,?,?)";

    String DELETE_USER_SQL = "delete from user where username = ?";

    String UPDATE_USER_SQL = "update user set password = ?, name = ?, mobile = ?, email = ?, head_image = ?, account_expire_date = ?, credential_expire_date = ?, account_locked = ?, enabled = ? where username = ?";

    String USER_EXISTS_SQL = "select username from user where username = ? or mobile = ?";

    String CHANGE_PASSWORD_SQL = "update user set password = ?, credential_expire_date = ? where username = ?";

    String USERS_BY_USERNAME_QUERY = "select username, password, name, mobile, email, head_image, account_expire_date, credential_expire_date, account_locked, enabled from user where username = ? or mobile = ?";
}
